﻿<%@ Page Title="" Language="C#" MasterPageFile="~/common.Master" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="Web1.WebForm2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">

        .auto-style1 {
            width: 50%;
            position: absolute;
            left: 232px;
            top: 150px;
            height: 342px;
            border-color: #99CCFF;
            margin-left: 1px;
        }
        .auto-style6 {
            width: 167px;
            height: 36px;
        }
        .auto-style7 {
            height: 36px;
        }
        .auto-style10 {
            width: 167px;
            height: 66px;
        }
        .auto-style9 {
            height: 263px;
            font-size: xx-large;
            font-family: 宋体;
        }
        .auto-style5 {
            width: 167px;
            height: 67px;
        }
        .auto-style3 {
            width: 167px;
            height: 30px;
        }
        .auto-style4 {
            height: 30px;
        }
        .auto-style49 {
            width: 50%;
            top: 45px;
            left: 177px;
        }
        .auto-style50 {
            font-size: small;
        }
        .auto-style11 {
            width: 60%;
            position: absolute;
            left: 212px;
            top: 57px;
            height: 253px;
            font-size: medium;
        }
        .auto-style19 {
            height: 40px;
        width: 81px;
    }
        .auto-style20 {
            height: 40px;
            width: 160px;
        }
        .auto-style45 {
            height: 73px;
        }
        .auto-style47 {
            height: 32px;
            width: 160px;
        }
        .auto-style29 {
    }
        .auto-style52 {
        width: 81px;
    }
        .auto-style53 {
            width: 10%;
            top: 57px;
            left: 554px;
            height: 36px;
        }
        .auto-style54 {
            position: absolute;
            height: 36px;
        }
        .auto-style55 {
            width: 17%;
            top: 47px;
            left: 28px;
            height: 58px;
        }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <p>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
</p>
    <asp:UpdatePanel ID="UpdatePanel2" runat="server">
        <ContentTemplate>
<br />
            <table="0" ="0" class="auto-style55" style="position: absolute; top: 71px; left: 18px; height: 38px; right: 490px;">
                <tr>
                    <td>
                        <asp:Timer ID="Timer1" runat="server" Interval="1000" OnTick="Page_Load">
                        </asp:Timer>
                        <asp:Label ID="Label1" runat="server"></asp:Label>
                    </td>
                </tr>
            </table>
            <br />
        </ContentTemplate>
    </asp:UpdatePanel>
    <p>
    <br />
</p>
    <table ="0" ="0" class="auto-style53" style="position: absolute; top: 40px; left: 1015px; width: 7%;">
        <tr>
            <td class="auto-style54">
                <asp:Button ID="Button5" runat="server" Font-Size="Large" PostBackUrl="~/default.aspx" Text="注销" />
            </td>
        </tr>
    </table>
    <table border="0" ="1" class="auto-style1">
        <tr>
            <td class="auto-style6">&nbsp;</td>
            <td class="auto-style7">学生信息管理&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="LinkButton1" runat="server" BackColor="White" BorderColor="#66CCFF" BorderStyle="Outset" Font-Bold="True" Font-Size="Large" ForeColor="Black" OnClick="LinkButton1_Click" PostBackUrl="~/WebForm2.aspx">查询数据</asp:LinkButton>
                &nbsp;</td>
            <td class="auto-style9" rowspan="4">
                <table ="1" class="auto-style11">
                <tr>
                    <td class="auto-style19">&nbsp;按学号查询</td>
                    <td class="auto-style20">
                        <asp:TextBox ID="txtNo" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style45" colspan="2">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="No" DataSourceID="SqlDataSource1" Font-Size="Small">
                            <Columns>
                                <asp:BoundField DataField="No" HeaderText="No" ReadOnly="True" SortExpression="No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                                <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                                <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112121ConnectionString %>" SelectCommand="SELECT * FROM [Student] WHERE ([No] = @No)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtNo" Name="No" PropertyName="Text" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style52">&nbsp;按姓名查询</td>
                    <td class="auto-style47">
                        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td class="auto-style29" colspan="2" style="position: absolute">
                        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="No" DataSourceID="SqlDataSource2" Font-Size="Small" Height="16px" Width="271px" OnSelectedIndexChanged="GridView2_SelectedIndexChanged">
                            <Columns>
                                <asp:BoundField DataField="No" HeaderText="No" ReadOnly="True" SortExpression="No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender" />
                                <asp:BoundField DataField="College" HeaderText="College" SortExpression="College" />
                                <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112121ConnectionString6 %>" SelectCommand="SELECT * FROM [Student] WHERE ([Name] = @Name)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtName" Name="Name" PropertyName="Text" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </td>
                </tr>
                </table>
&nbsp;&nbsp;&nbsp;<table ="1" class="auto-style49" style="position: absolute">
                    <tr>
                        <td class="auto-style50">查询数据</td>
                    </tr>
                </table>
                <br />
&nbsp;<br />
            </td>
        </tr>
        <tr>
            <td class="auto-style10">&nbsp;&nbsp;&nbsp; &nbsp;
                <asp:LinkButton ID="LinkButton2" runat="server" BackColor="White" BorderColor="#66CCFF" BorderStyle="Outset" Font-Bold="True" Font-Size="Large" ForeColor="Black" OnClick="LinkButton2_Click" PostBackUrl="~/WebForm3.aspx">增加数据</asp:LinkButton>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style5">&nbsp;&nbsp;&nbsp; &nbsp;
                <asp:LinkButton ID="LinkButton3" runat="server" BackColor="White" BorderColor="#66CCFF" BorderStyle="Outset" Font-Bold="True" Font-Size="Large" ForeColor="Black" OnClick="LinkButton3_Click" PostBackUrl="~/WebForm4.aspx">删除数据</asp:LinkButton>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style5">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="LinkButton4" runat="server" BackColor="White" BorderColor="#66CCFF" BorderStyle="Outset" Font-Bold="True" Font-Size="Large" ForeColor="Black" OnClick="LinkButton4_Click" PostBackUrl="~/WebForm5.aspx">更新数据</asp:LinkButton>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style3">&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>
            <td class="auto-style4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" />
            &nbsp;
                <asp:Button ID="Button2" runat="server" Text="查询全部学生信息" PostBackUrl="~/WebForm6.aspx" OnClick="Button2_Click" />
            </td>
        </tr>
    </table>
<p>
    &nbsp;</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;</p>
    <p>
        &nbsp;</p>
<p>
    &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <table class="auto-style11" style="position: absolute; top: 176px; left: 51px; height: 260px; width: 18%;">
        <tr>
            <td class="auto-style52">&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:TreeView ID="TreeView1" runat="server" ImageSet="Arrows">
                    <HoverNodeStyle BackColor="#99CCFF" Font-Size="Large" Font-Underline="True" ForeColor="#5555DD" />
                    <Nodes>
                        <asp:TreeNode NavigateUrl="~/WebForm1.aspx" Text="学生管理" Value="学生管理">
                            <asp:TreeNode NavigateUrl="~/WebForm2.aspx" Text="学生信息管理" Value="学生信息管理"></asp:TreeNode>
                            <asp:TreeNode NavigateUrl="~/WebForm8.aspx" Text="学生成绩管理" Value="学生成绩管理"></asp:TreeNode>
                        </asp:TreeNode>
                    </Nodes>
                    <NodeStyle Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px" NodeSpacing="0px" VerticalPadding="0px" />
                    <ParentNodeStyle Font-Bold="False" />
                    <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px" VerticalPadding="0px" />
                </asp:TreeView>
            </td>
        </tr>
        <tr>
            <td>
                <asp:TreeView ID="TreeView2" runat="server" ImageSet="Arrows">
                    <HoverNodeStyle BackColor="#99CCFF" Font-Size="Large" Font-Underline="True" ForeColor="#5555DD" />
                    <Nodes>
                        <asp:TreeNode Text="用户管理" Value="用户管理" NavigateUrl="~/WebForm10.aspx">
                            <asp:TreeNode Text="用户信息管理" Value="用户信息管理" NavigateUrl="~/WebForm10.aspx"></asp:TreeNode>
                            <asp:TreeNode Text="修改密码" Value="修改密码" NavigateUrl="~/WebForm11.aspx"></asp:TreeNode>
                        </asp:TreeNode>
                    </Nodes>
                    <NodeStyle Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px" NodeSpacing="0px" VerticalPadding="0px" />
                    <ParentNodeStyle Font-Bold="False" />
                    <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px" VerticalPadding="0px" />
                </asp:TreeView>
            </td>
        </tr>
    </table>
    </asp:Content>
